Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	46527
Missing cells	21475
Missing cells (%)	2.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	22.4 MiB
Average record size in memory	503.9 B

Variable types

Numeric	10
Text	3
Categorical	2
DateTime	1

Alerts

`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id`	High correlation
`latitude` is highly overall correlated with `neighbourhood_group`	High correlation
`longitude` is highly overall correlated with `neighbourhood_group`	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`neighbourhood_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`last_review` has 10711 (23.0%) missing values	Missing
`reviews_per_month` has 10711 (23.0%) missing values	Missing
`price` is highly skewed (γ1 = 21.55255255)	Skewed
`id` has unique values	Unique
`number_of_reviews` has 10711 (23.0%) zeros	Zeros
`availability_365` has 19967 (42.9%) zeros	Zeros

Reproduction

Analysis started	2023-09-06 02:53:00.246640
Analysis finished	2023-09-06 02:53:10.871117
Duration	10.62 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	46527
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22998909

Minimum	2595
Maximum	44818009
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	2595
5-th percentile	1567876.3
Q1	10625576
median	22205277
Q3	35754400
95-th percentile	43273246
Maximum	44818009
Range	44815414
Interquartile range (IQR)	25128824

Descriptive statistics

Standard deviation	13731230
Coefficient of variation (CV)	0.59703832
Kurtosis	-1.2904723
Mean	22998909
Median Absolute Deviation (MAD)	12472050
Skewness	-0.022291119
Sum	1.0700702 × 10¹²
Variance	1.8854667 × 10¹⁴
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2595	1	< 0.1%
31221559	1	< 0.1%
31221996	1	< 0.1%
31223352	1	< 0.1%
31223941	1	< 0.1%
31224224	1	< 0.1%
31224372	1	< 0.1%
31224656	1	< 0.1%
31225319	1	< 0.1%
31225706	1	< 0.1%
Other values (46517)	46517	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2595	1	< 0.1%
3831	1	< 0.1%
5121	1	< 0.1%
5136	1	< 0.1%
5178	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5552	1	< 0.1%
5803	1	< 0.1%
6021	1	< 0.1%

Value	Count	Frequency (%)
44818009	1	< 0.1%
44814944	1	< 0.1%
44811717	1	< 0.1%
44807786	1	< 0.1%
44807522	1	< 0.1%
44807338	1	< 0.1%
44804690	1	< 0.1%
44803201	1	< 0.1%
44802224	1	< 0.1%
44802032	1	< 0.1%

name
Text

Distinct	45315
Distinct (%)	97.4%
Missing	18
Missing (%)	< 0.1%
Memory size	4.3 MiB

Length

Max length	161
Median length	84
Mean length	37.0699
Min length	1

Characters and Unicode

Total characters	1724084
Distinct characters	821
Distinct categories	21 ?
Distinct scripts	11 ?
Distinct blocks	23 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	44557 ?
Unique (%)	95.8%

Sample

1st row	Skylit Midtown Castle
2nd row	Whole flr w/private bdrm, bath & kitchen(pls read)
3rd row	BlissArtsSpace!
4th row	Spacious Brooklyn Duplex, Patio + Garden
5th row	Large Furnished Room Near B'way

Value	Count	Frequency (%)
in	15849	5.6%
room	9555	3.4%
	7592	2.7%
bedroom	7205	2.5%
private	6640	2.3%
apartment	6582	2.3%
cozy	4770	1.7%
apt	4244	1.5%
the	3875	1.4%
studio	3824	1.3%
Other values (12473)	214895	75.4%

Most occurring characters

Value	Count	Frequency (%)
	239964	13.9%
e	121301	7.0%
o	117959	6.8%
t	101776	5.9%
a	100450	5.8%
r	93857	5.4%
i	91748	5.3%
n	91492	5.3%
l	50822	2.9%
m	47502	2.8%
Other values (811)	667213	38.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1167051	67.7%
Uppercase Letter	245781	14.3%
Space Separator	239980	13.9%
Other Punctuation	32115	1.9%
Decimal Number	23719	1.4%
Dash Punctuation	6420	0.4%
Math Symbol	2163	0.1%
Other Letter	2091	0.1%
Close Punctuation	1439	0.1%
Open Punctuation	1357	0.1%
Other values (11)	1968	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
房	71	3.4%
间	48	2.3%
拉	35	1.7%
法	35	1.7%
大	33	1.6%
盛	33	1.6%
人	29	1.4%
中	28	1.3%
家	27	1.3%
纽	24	1.1%
Other values (473)	1728	82.6%

Other Symbol

Value	Count	Frequency (%)
★	336	30.8%
❤	162	14.8%
☆	110	10.1%
⭐	54	4.9%
♥	46	4.2%
☀	22	2.0%
♪	21	1.9%
✨	21	1.9%
❥	18	1.6%
✿	15	1.4%
Other values (115)	287	26.3%

Lowercase Letter

Value	Count	Frequency (%)
e	121301	10.4%
o	117959	10.1%
t	101776	8.7%
a	100450	8.6%
r	93857	8.0%
i	91748	7.9%
n	91492	7.8%
l	50822	4.4%
m	47502	4.1%
s	46745	4.0%
Other values (57)	303399	26.0%

Uppercase Letter

Value	Count	Frequency (%)
B	27625	11.2%
S	24027	9.8%
C	19855	8.1%
A	17892	7.3%
R	16015	6.5%
P	13770	5.6%
L	12438	5.1%
E	12085	4.9%
M	11088	4.5%
N	10646	4.3%
Other values (43)	80340	32.7%

Other Punctuation

Value	Count	Frequency (%)
,	9057	28.2%
!	6761	21.1%
/	5081	15.8%
.	4425	13.8%
&	3160	9.8%
'	1031	3.2%
*	782	2.4%
:	565	1.8%
#	508	1.6%
"	261	0.8%
Other values (15)	484	1.5%

Decimal Number

Value	Count	Frequency (%)
1	7891	33.3%
2	6413	27.0%
3	2487	10.5%
0	2067	8.7%
5	2003	8.4%
4	1271	5.4%
6	468	2.0%
8	425	1.8%
7	410	1.7%
9	278	1.2%
Other values (4)	6	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	1040	48.1%
\|	621	28.7%
~	309	14.3%
=	90	4.2%
<	43	2.0%
>	39	1.8%
→	13	0.6%
⋆	4	0.2%
≖	2	0.1%
⇒	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	1362	94.6%
]	37	2.6%
）	24	1.7%
}	9	0.6%
】	5	0.3%
》	2	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	1281	94.4%
[	37	2.7%
（	23	1.7%
{	9	0.7%
【	5	0.4%
《	2	0.1%

Modifier Symbol

Value	Count	Frequency (%)
^	7	38.9%
´	5	27.8%
`	3	16.7%
🏻	1	5.6%
🏼	1	5.6%
🏾	1	5.6%

Dash Punctuation

Value	Count	Frequency (%)
-	6353	99.0%
—	39	0.6%
–	25	0.4%
－	2	< 0.1%
―	1	< 0.1%

Nonspacing Mark

Value	Count	Frequency (%)
️	208	90.8%
︎	18	7.9%
͠	2	0.9%
͜	1	0.4%

Space Separator

Value	Count	Frequency (%)
	239964	> 99.9%
	9	< 0.1%
	7	< 0.1%

Final Punctuation

Value	Count	Frequency (%)
’	237	83.5%
”	47	16.5%

Control

Value	Count	Frequency (%)
	148	99.3%
	1	0.7%

Initial Punctuation

Value	Count	Frequency (%)
“	44	86.3%
‘	7	13.7%

Connector Punctuation

Value	Count	Frequency (%)
_	32	97.0%
‿	1	3.0%

Other Number

Value	Count	Frequency (%)
²	9	81.8%
½	2	18.2%

Currency Symbol

Value	Count	Frequency (%)
$	81	100.0%

Modifier Letter

Value	Count	Frequency (%)
ー	12	100.0%

Format

Value	Count	Frequency (%)
‍	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1412559	81.9%
Common	308929	17.9%
Han	1775	0.1%
Cyrillic	273	< 0.1%
Inherited	237	< 0.1%
Katakana	155	< 0.1%
Hiragana	75	< 0.1%
Hebrew	40	< 0.1%
Hangul	39	< 0.1%
Georgian	1	< 0.1%

Most frequent character per script

Han

Value	Count	Frequency (%)
房	71	4.0%
间	48	2.7%
拉	35	2.0%
法	35	2.0%
大	33	1.9%
盛	33	1.9%
人	29	1.6%
中	28	1.6%
家	27	1.5%
纽	24	1.4%
Other values (360)	1412	79.5%

Common

Value	Count	Frequency (%)
	239964	77.7%
,	9057	2.9%
1	7891	2.6%
!	6761	2.2%
2	6413	2.1%
-	6353	2.1%
/	5081	1.6%
.	4425	1.4%
&	3160	1.0%
3	2487	0.8%
Other values (203)	17337	5.6%

Latin

Value	Count	Frequency (%)
e	121301	8.6%
o	117959	8.4%
t	101776	7.2%
a	100450	7.1%
r	93857	6.6%
i	91748	6.5%
n	91492	6.5%
l	50822	3.6%
m	47502	3.4%
s	46745	3.3%
Other values (67)	548907	38.9%

Cyrillic

Value	Count	Frequency (%)
а	35	12.8%
н	24	8.8%
о	22	8.1%
т	20	7.3%
е	15	5.5%
р	14	5.1%
к	13	4.8%
я	9	3.3%
м	9	3.3%
с	8	2.9%
Other values (33)	104	38.1%

Katakana

Value	Count	Frequency (%)
ン	19	12.3%
ッ	11	7.1%
リ	10	6.5%
ル	8	5.2%
ク	8	5.2%
ア	8	5.2%
ウ	7	4.5%
タ	6	3.9%
ム	5	3.2%
ト	5	3.2%
Other values (31)	68	43.9%

Hangul

Value	Count	Frequency (%)
맨	2	5.1%
리	2	5.1%
스	2	5.1%
트	1	2.6%
빌	1	2.6%
웨	1	2.6%
튼	1	2.6%
소	1	2.6%
호	1	2.6%
거	1	2.6%
Other values (26)	26	66.7%

Hiragana

Value	Count	Frequency (%)
の	16	21.3%
で	9	12.0%
か	8	10.7%
ら	7	9.3%
な	6	8.0%
き	4	5.3%
お	4	5.3%
ま	3	4.0%
に	3	4.0%
す	2	2.7%
Other values (10)	13	17.3%

Hebrew

Value	Count	Frequency (%)
ו	7	17.5%
ר	5	12.5%
ב	5	12.5%
ש	5	12.5%
י	4	10.0%
מ	3	7.5%
ת	3	7.5%
ה	2	5.0%
ל	1	2.5%
ד	1	2.5%
Other values (4)	4	10.0%

Inherited

Value	Count	Frequency (%)
️	208	87.8%
︎	18	7.6%
‍	8	3.4%
͠	2	0.8%
͜	1	0.4%

Georgian

Value	Count	Frequency (%)
ღ	1	100.0%

Arabic

Value	Count	Frequency (%)
٪	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1719584	99.7%
CJK	1775	0.1%
Misc Symbols	593	< 0.1%
None	500	< 0.1%
Punctuation	452	< 0.1%
Dingbats	310	< 0.1%
Cyrillic	273	< 0.1%
VS	226	< 0.1%
Katakana	169	< 0.1%
Hiragana	75	< 0.1%
Other values (13)	127	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	239964	14.0%
e	121301	7.1%
o	117959	6.9%
t	101776	5.9%
a	100450	5.8%
r	93857	5.5%
i	91748	5.3%
n	91492	5.3%
l	50822	3.0%
m	47502	2.8%
Other values (87)	662713	38.5%

Misc Symbols

Value	Count	Frequency (%)
★	336	56.7%
☆	110	18.5%
♥	46	7.8%
☀	22	3.7%
♪	21	3.5%
♡	14	2.4%
⚡	9	1.5%
⚜	5	0.8%
⛱	4	0.7%
♦	3	0.5%
Other values (15)	23	3.9%

Punctuation

Value	Count	Frequency (%)
’	237	52.4%
”	47	10.4%
“	44	9.7%
•	43	9.5%
—	39	8.6%
–	25	5.5%
‍	8	1.8%
‘	7	1.5%
‿	1	0.2%
―	1	0.2%

VS

Value	Count	Frequency (%)
️	208	92.0%
︎	18	8.0%

Dingbats

Value	Count	Frequency (%)
❤	162	52.3%
✨	21	6.8%
❥	18	5.8%
✿	15	4.8%
✰	13	4.2%
✦	12	3.9%
✪	10	3.2%
❄	7	2.3%
❃	6	1.9%
✶	6	1.9%
Other values (15)	40	12.9%

CJK

Value	Count	Frequency (%)
房	71	4.0%
间	48	2.7%
拉	35	2.0%
法	35	2.0%
大	33	1.9%
盛	33	1.9%
人	29	1.6%
中	28	1.6%
家	27	1.5%
纽	24	1.4%
Other values (360)	1412	79.5%

None

Value	Count	Frequency (%)
⭐	54	10.8%
ó	46	9.2%
，	33	6.6%
à	27	5.4%
）	24	4.8%
（	23	4.6%
·	17	3.4%
🌟	15	3.0%
é	13	2.6%
！	13	2.6%
Other values (102)	235	47.0%

Cyrillic

Value	Count	Frequency (%)
а	35	12.8%
н	24	8.8%
о	22	8.1%
т	20	7.3%
е	15	5.5%
р	14	5.1%
к	13	4.8%
я	9	3.3%
м	9	3.3%
с	8	2.9%
Other values (33)	104	38.1%

Katakana

Value	Count	Frequency (%)
ン	19	11.2%
ー	12	7.1%
ッ	11	6.5%
リ	10	5.9%
ル	8	4.7%
ク	8	4.7%
ア	8	4.7%
ウ	7	4.1%
タ	6	3.6%
ム	5	3.0%
Other values (33)	75	44.4%

Hiragana

Value	Count	Frequency (%)
の	16	21.3%
で	9	12.0%
か	8	10.7%
ら	7	9.3%
な	6	8.0%
き	4	5.3%
お	4	5.3%
ま	3	4.0%
に	3	4.0%
す	2	2.7%
Other values (10)	13	17.3%

Arrows

Value	Count	Frequency (%)
→	13	92.9%
⇒	1	7.1%

Hebrew

Value	Count	Frequency (%)
ו	7	17.5%
ר	5	12.5%
ב	5	12.5%
ש	5	12.5%
י	4	10.0%
מ	3	7.5%
ת	3	7.5%
ה	2	5.0%
ל	1	2.5%
ד	1	2.5%
Other values (4)	4	10.0%

Math Operators

Value	Count	Frequency (%)
⋆	4	57.1%
≖	2	28.6%
⊹	1	14.3%

Geometric Shapes

Value	Count	Frequency (%)
▲	4	44.4%
◔	2	22.2%
◈	2	22.2%
▶	1	11.1%

Hangul

Value	Count	Frequency (%)
맨	2	5.1%
리	2	5.1%
스	2	5.1%
트	1	2.6%
빌	1	2.6%
웨	1	2.6%
튼	1	2.6%
소	1	2.6%
호	1	2.6%
거	1	2.6%
Other values (26)	26	66.7%

Diacriticals

Value	Count	Frequency (%)
͠	2	66.7%
͜	1	33.3%

Emoticons

Value	Count	Frequency (%)
😁	2	28.6%
😍	2	28.6%
🙊	1	14.3%
😃	1	14.3%
😊	1	14.3%

Georgian

Value	Count	Frequency (%)
ღ	1	100.0%

Enclosed Alphanum Sup

Value	Count	Frequency (%)
🇯	1	50.0%
🇵	1	50.0%

Misc Technical

Value	Count	Frequency (%)
⏪	1	50.0%
⏩	1	50.0%

IPA Ext

Value	Count	Frequency (%)
ʖ	1	100.0%

Enclosed Alphanum

Value	Count	Frequency (%)
Ⓜ	1	100.0%

Arabic

Value	Count	Frequency (%)
٪	1	100.0%

host_id
Real number (ℝ)

HIGH CORRELATION

Distinct	35399
Distinct (%)	76.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84391858

Minimum	2438
Maximum	3.6245369 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	2438
5-th percentile	908631.6
Q1	9194284
median	37194964
Q3	1.3622744 × 10⁸
95-th percentile	3.0258672 × 10⁸
Maximum	3.6245369 × 10⁸
Range	3.6245125 × 10⁸
Interquartile range (IQR)	1.2703316 × 10⁸

Descriptive statistics

Standard deviation	99132599
Coefficient of variation (CV)	1.1746702
Kurtosis	0.197352
Mean	84391858
Median Absolute Deviation (MAD)	33768999
Skewness	1.2080481
Sum	3.9265 × 10¹²
Variance	9.8272723 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107434423	249	0.5%
137358866	138	0.3%
61391963	118	0.3%
19303369	98	0.2%
334163301	83	0.2%
51501835	78	0.2%
48005494	77	0.2%
22541573	74	0.2%
204704622	72	0.2%
9419684	62	0.1%
Other values (35389)	45478	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2438	1	< 0.1%
2571	1	< 0.1%
2782	3	< 0.1%
2787	7	< 0.1%
2845	2	< 0.1%
2868	1	< 0.1%
2881	2	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%

Value	Count	Frequency (%)
362453686	1	< 0.1%
362419479	1	< 0.1%
362369539	1	< 0.1%
362241319	1	< 0.1%
362166123	1	< 0.1%
361977539	1	< 0.1%
361973567	1	< 0.1%
361814116	1	< 0.1%
361692734	1	< 0.1%
361596683	1	< 0.1%

host_name
Text

Distinct	11094
Distinct (%)	23.9%
Missing	35
Missing (%)	0.1%
Memory size	2.8 MiB

Length

Max length	37
Median length	33
Mean length	6.2124021
Min length	1

Characters and Unicode

Total characters	288827
Distinct characters	213
Distinct categories	15 ?
Distinct scripts	7 ?
Distinct blocks	10 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6645 ?
Unique (%)	14.3%

Sample

1st row	Jennifer
2nd row	LisaRoxanne
3rd row	Garon
4th row	Rebecca
5th row	Shunichi

Value	Count	Frequency (%)
	811	1.6%
and	623	1.2%
michael	434	0.8%
david	375	0.7%
john	312	0.6%
hotel	304	0.6%
alex	291	0.6%
daniel	269	0.5%
mike	258	0.5%
the	254	0.5%
Other values (10096)	48205	92.5%

Most occurring characters

Value	Count	Frequency (%)
a	36157	12.5%
e	27817	9.6%
i	23612	8.2%
n	22740	7.9%
r	17161	5.9%
l	15022	5.2%
o	13069	4.5%
t	9388	3.3%
s	9099	3.2%
h	8822	3.1%
Other values (203)	105940	36.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	228979	79.3%
Uppercase Letter	52216	18.1%
Space Separator	5684	2.0%
Other Punctuation	1162	0.4%
Decimal Number	250	0.1%
Dash Punctuation	172	0.1%
Other Letter	121	< 0.1%
Open Punctuation	91	< 0.1%
Close Punctuation	90	< 0.1%
Math Symbol	46	< 0.1%
Other values (5)	16	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
美	5	4.1%
青	5	4.1%
明	5	4.1%
德	5	4.1%
媛	3	2.5%
安	3	2.5%
达	3	2.5%
常	3	2.5%
春	3	2.5%
辣	2	1.7%
Other values (69)	84	69.4%

Lowercase Letter

Value	Count	Frequency (%)
a	36157	15.8%
e	27817	12.1%
i	23612	10.3%
n	22740	9.9%
r	17161	7.5%
l	15022	6.6%
o	13069	5.7%
t	9388	4.1%
s	9099	4.0%
h	8822	3.9%
Other values (52)	46092	20.1%

Uppercase Letter

Value	Count	Frequency (%)
A	6146	11.8%
M	5068	9.7%
J	4981	9.5%
S	4498	8.6%
C	3456	6.6%
D	2678	5.1%
L	2638	5.1%
R	2453	4.7%
K	2413	4.6%
E	2284	4.4%
Other values (32)	15601	29.9%

Other Punctuation

Value	Count	Frequency (%)
&	810	69.7%
.	247	21.3%
,	36	3.1%
'	30	2.6%
/	25	2.2%
"	6	0.5%
@	4	0.3%
:	2	0.2%
!	2	0.2%

Decimal Number

Value	Count	Frequency (%)
3	62	24.8%
6	41	16.4%
4	36	14.4%
2	36	14.4%
5	20	8.0%
8	17	6.8%
7	14	5.6%
0	14	5.6%
1	10	4.0%

Math Symbol

Value	Count	Frequency (%)
+	37	80.4%
\|	9	19.6%

Other Symbol

Value	Count	Frequency (%)
★	2	66.7%
✨	1	33.3%

Space Separator

Value	Count	Frequency (%)
	5684	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	172	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	91	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	90	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	9	100.0%

Format

Value	Count	Frequency (%)
	2	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	281128	97.3%
Common	7511	2.6%
Han	106	< 0.1%
Cyrillic	67	< 0.1%
Hangul	7	< 0.1%
Hebrew	5	< 0.1%
Hiragana	3	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	36157	12.9%
e	27817	9.9%
i	23612	8.4%
n	22740	8.1%
r	17161	6.1%
l	15022	5.3%
o	13069	4.6%
t	9388	3.3%
s	9099	3.2%
h	8822	3.1%
Other values (70)	98241	34.9%

Han

Value	Count	Frequency (%)
美	5	4.7%
青	5	4.7%
明	5	4.7%
德	5	4.7%
媛	3	2.8%
安	3	2.8%
达	3	2.8%
常	3	2.8%
春	3	2.8%
辣	2	1.9%
Other values (54)	69	65.1%

Common

Value	Count	Frequency (%)
	5684	75.7%
&	810	10.8%
.	247	3.3%
-	172	2.3%
(	91	1.2%
)	90	1.2%
3	62	0.8%
6	41	0.5%
+	37	0.5%
,	36	0.5%
Other values (20)	241	3.2%

Cyrillic

Value	Count	Frequency (%)
а	12	17.9%
и	8	11.9%
н	7	10.4%
л	4	6.0%
е	4	6.0%
А	4	6.0%
р	4	6.0%
к	2	3.0%
я	2	3.0%
з	2	3.0%
Other values (14)	18	26.9%

Hangul

Value	Count	Frequency (%)
진	1	14.3%
비	1	14.3%
단	1	14.3%
선	1	14.3%
현	1	14.3%
정	1	14.3%
소	1	14.3%

Hebrew

Value	Count	Frequency (%)
ל	1	20.0%
א	1	20.0%
י	1	20.0%
נ	1	20.0%
ד	1	20.0%

Hiragana

Value	Count	Frequency (%)
あ	1	33.3%
り	1	33.3%
ゆ	1	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	288384	99.8%
None	241	0.1%
CJK	106	< 0.1%
Cyrillic	67	< 0.1%
Punctuation	11	< 0.1%
Hangul	7	< 0.1%
Hebrew	5	< 0.1%
Hiragana	3	< 0.1%
Misc Symbols	2	< 0.1%
Dingbats	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	36157	12.5%
e	27817	9.6%
i	23612	8.2%
n	22740	7.9%
r	17161	6.0%
l	15022	5.2%
o	13069	4.5%
t	9388	3.3%
s	9099	3.2%
h	8822	3.1%
Other values (67)	105497	36.6%

None

Value	Count	Frequency (%)
é	101	41.9%
á	21	8.7%
í	20	8.3%
ë	15	6.2%
ü	10	4.1%
ı	9	3.7%
ó	8	3.3%
ê	7	2.9%
è	6	2.5%
ï	5	2.1%
Other values (19)	39	16.2%

Cyrillic

Value	Count	Frequency (%)
а	12	17.9%
и	8	11.9%
н	7	10.4%
л	4	6.0%
е	4	6.0%
А	4	6.0%
р	4	6.0%
к	2	3.0%
я	2	3.0%
з	2	3.0%
Other values (14)	18	26.9%

Punctuation

Value	Count	Frequency (%)
’	9	81.8%
	2	18.2%

CJK

Value	Count	Frequency (%)
美	5	4.7%
青	5	4.7%
明	5	4.7%
德	5	4.7%
媛	3	2.8%
安	3	2.8%
达	3	2.8%
常	3	2.8%
春	3	2.8%
辣	2	1.9%
Other values (54)	69	65.1%

Misc Symbols

Value	Count	Frequency (%)
★	2	100.0%

Dingbats

Value	Count	Frequency (%)
✨	1	100.0%

Hangul

Value	Count	Frequency (%)
진	1	14.3%
비	1	14.3%
단	1	14.3%
선	1	14.3%
현	1	14.3%
정	1	14.3%
소	1	14.3%

Hebrew

Value	Count	Frequency (%)
ל	1	20.0%
א	1	20.0%
י	1	20.0%
נ	1	20.0%
ד	1	20.0%

Hiragana

Value	Count	Frequency (%)
あ	1	33.3%
り	1	33.3%
ゆ	1	33.3%

neighbourhood_group
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.9 MiB

Manhattan	20580
Brooklyn	18632
Queens	5791
Bronx	1183
Staten Island	341

Length

Max length	13
Median length	9
Mean length	8.1537602
Min length	5

Characters and Unicode

Total characters	379370
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manhattan
2nd row	Brooklyn
3rd row	Brooklyn
4th row	Brooklyn
5th row	Manhattan

Common Values

Value	Count	Frequency (%)
Manhattan	20580	44.2%
Brooklyn	18632	40.0%
Queens	5791	12.4%
Bronx	1183	2.5%
Staten Island	341	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	20580	43.9%
brooklyn	18632	39.8%
queens	5791	12.4%
bronx	1183	2.5%
staten	341	0.7%
island	341	0.7%

Most occurring characters

Value	Count	Frequency (%)
n	67448	17.8%
a	62422	16.5%
t	41842	11.0%
o	38447	10.1%
M	20580	5.4%
h	20580	5.4%
B	19815	5.2%
r	19815	5.2%
l	18973	5.0%
y	18632	4.9%
Other values (10)	50816	13.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	332161	87.6%
Uppercase Letter	46868	12.4%
Space Separator	341	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	67448	20.3%
a	62422	18.8%
t	41842	12.6%
o	38447	11.6%
h	20580	6.2%
r	19815	6.0%
l	18973	5.7%
y	18632	5.6%
k	18632	5.6%
e	11923	3.6%
Other values (4)	13447	4.0%

Uppercase Letter

Value	Count	Frequency (%)
M	20580	43.9%
B	19815	42.3%
Q	5791	12.4%
S	341	0.7%
I	341	0.7%

Space Separator

Value	Count	Frequency (%)
	341	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	379029	99.9%
Common	341	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	67448	17.8%
a	62422	16.5%
t	41842	11.0%
o	38447	10.1%
M	20580	5.4%
h	20580	5.4%
B	19815	5.2%
r	19815	5.2%
l	18973	5.0%
y	18632	4.9%
Other values (9)	50475	13.3%

Common

Value	Count	Frequency (%)
	341	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	379370	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	67448	17.8%
a	62422	16.5%
t	41842	11.0%
o	38447	10.1%
M	20580	5.4%
h	20580	5.4%
B	19815	5.2%
r	19815	5.2%
l	18973	5.0%
y	18632	4.9%
Other values (10)	50816	13.4%

neighbourhood
Text

Distinct	222
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Length

Max length	26
Median length	17
Mean length	11.81054
Min length	4

Characters and Unicode

Total characters	549509
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	Midtown
2nd row	Clinton Hill
3rd row	Bedford-Stuyvesant
4th row	Sunset Park
5th row	Hell's Kitchen

Value	Count	Frequency (%)
east	6129	8.2%
side	4311	5.7%
harlem	3504	4.7%
williamsburg	3486	4.6%
upper	3481	4.6%
heights	3458	4.6%
bedford-stuyvesant	3438	4.6%
village	2921	3.9%
west	2555	3.4%
bushwick	2225	3.0%
Other values (234)	39466	52.6%

Most occurring characters

Value	Count	Frequency (%)
e	50804	9.2%
i	39418	7.2%
s	37584	6.8%
t	36671	6.7%
a	35536	6.5%
l	32223	5.9%
r	31525	5.7%
	28447	5.2%
n	24845	4.5%
o	23311	4.2%
Other values (44)	209145	38.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	435611	79.3%
Uppercase Letter	79497	14.5%
Space Separator	28447	5.2%
Dash Punctuation	3953	0.7%
Other Punctuation	2001	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	50804	11.7%
i	39418	9.0%
s	37584	8.6%
t	36671	8.4%
a	35536	8.2%
l	32223	7.4%
r	31525	7.2%
n	24845	5.7%
o	23311	5.4%
d	18918	4.3%
Other values (15)	104776	24.1%

Uppercase Letter

Value	Count	Frequency (%)
H	11308	14.2%
S	10717	13.5%
B	7787	9.8%
W	7674	9.7%
E	6661	8.4%
C	5248	6.6%
U	3554	4.5%
G	3473	4.4%
M	3033	3.8%
V	2960	3.7%
Other values (14)	17082	21.5%

Other Punctuation

Value	Count	Frequency (%)
'	1864	93.2%
.	136	6.8%
,	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	28447	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3953	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	515108	93.7%
Common	34401	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	50804	9.9%
i	39418	7.7%
s	37584	7.3%
t	36671	7.1%
a	35536	6.9%
l	32223	6.3%
r	31525	6.1%
n	24845	4.8%
o	23311	4.5%
d	18918	3.7%
Other values (39)	184273	35.8%

Common

Value	Count	Frequency (%)
	28447	82.7%
-	3953	11.5%
'	1864	5.4%
.	136	0.4%
,	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	549509	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	50804	9.2%
i	39418	7.2%
s	37584	6.8%
t	36671	6.7%
a	35536	6.5%
l	32223	5.9%
r	31525	5.7%
	28447	5.2%
n	24845	4.5%
o	23311	4.2%
Other values (44)	209145	38.1%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	18831
Distinct (%)	40.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.729563

Minimum	40.50868
Maximum	40.91169
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	40.50868
5-th percentile	40.645636
Q1	40.689945
median	40.7244
Q3	40.76304
95-th percentile	40.827285
Maximum	40.91169
Range	0.40301
Interquartile range (IQR)	0.073095

Descriptive statistics

Standard deviation	0.05497412
Coefficient of variation (CV)	0.0013497351
Kurtosis	0.12870231
Mean	40.729563
Median Absolute Deviation (MAD)	0.03659
Skewness	0.2414261
Sum	1895024.4
Variance	0.0030221539
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.76411	37	0.1%
40.76076	27	0.1%
40.71579	24	0.1%
40.73837	23	< 0.1%
40.72179	23	< 0.1%
40.73756	22	< 0.1%
40.75544	21	< 0.1%
40.71813	16	< 0.1%
40.76211	16	< 0.1%
40.74871	16	< 0.1%
Other values (18821)	46302	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.50868	1	< 0.1%
40.52211	1	< 0.1%
40.52293	1	< 0.1%
40.53076	1	< 0.1%
40.53871	1	< 0.1%
40.53884	1	< 0.1%
40.53907	1	< 0.1%
40.54106	1	< 0.1%
40.54268	1	< 0.1%
40.54312	1	< 0.1%

Value	Count	Frequency (%)
40.91169	1	< 0.1%
40.91055	1	< 0.1%
40.91051	1	< 0.1%
40.91031	1	< 0.1%
40.90804	1	< 0.1%
40.90734	1	< 0.1%
40.90659	1	< 0.1%
40.9059	1	< 0.1%
40.90578	1	< 0.1%
40.90491	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	14651
Distinct (%)	31.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.950918

Minimum	-74.23986
Maximum	-73.71299
Zeros	0
Zeros (%)	0.0%
Negative	46527
Negative (%)	100.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	-74.23986
5-th percentile	-74.00329
Q1	-73.98317
median	-73.95538
Q3	-73.93417
95-th percentile	-73.859549
Maximum	-73.71299
Range	0.52687
Interquartile range (IQR)	0.049

Descriptive statistics

Standard deviation	0.047562221
Coefficient of variation (CV)	-0.00064315931
Kurtosis	4.5922732
Mean	-73.950918
Median Absolute Deviation (MAD)	0.02565
Skewness	1.3568077
Sum	-3440714.4
Variance	0.0022621649
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.99371	42	0.1%
-73.99675	31	0.1%
-73.9535	29	0.1%
-73.98611	27	0.1%
-74.00588	22	< 0.1%
-73.97244	19	< 0.1%
-73.98702	18	< 0.1%
-73.95627	18	< 0.1%
-73.98276	17	< 0.1%
-73.99773	17	< 0.1%
Other values (14641)	46287	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.23986	1	< 0.1%
-74.21238	1	< 0.1%
-74.20877	1	< 0.1%
-74.20295	1	< 0.1%
-74.19826	1	< 0.1%
-74.18305	1	< 0.1%
-74.18259	1	< 0.1%
-74.18028	1	< 0.1%
-74.17628	1	< 0.1%
-74.17459	1	< 0.1%

Value	Count	Frequency (%)
-73.71299	1	< 0.1%
-73.7174	1	< 0.1%
-73.71928	1	< 0.1%
-73.72173	1	< 0.1%
-73.72179	1	< 0.1%
-73.72435	1	< 0.1%
-73.72506	1	< 0.1%
-73.72569	1	< 0.1%
-73.72582	1	< 0.1%
-73.72656	1	< 0.1%

room_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Entire home/apt	23998
Private room	21144
Shared room	987
Hotel room	398

Length

Max length	15
Median length	15
Mean length	13.509038
Min length	10

Characters and Unicode

Total characters	628535
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Entire home/apt
2nd row	Entire home/apt
3rd row	Private room
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	23998	51.6%
Private room	21144	45.4%
Shared room	987	2.1%
Hotel room	398	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	23998	25.8%
home/apt	23998	25.8%
room	22529	24.2%
private	21144	22.7%
shared	987	1.1%
hotel	398	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	70525	11.2%
t	69538	11.1%
o	69454	11.1%
r	68658	10.9%
m	46527	7.4%
	46527	7.4%
a	46129	7.3%
i	45142	7.2%
h	24985	4.0%
p	23998	3.8%
Other values (9)	117052	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	511483	81.4%
Space Separator	46527	7.4%
Uppercase Letter	46527	7.4%
Other Punctuation	23998	3.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	70525	13.8%
t	69538	13.6%
o	69454	13.6%
r	68658	13.4%
m	46527	9.1%
a	46129	9.0%
i	45142	8.8%
h	24985	4.9%
p	23998	4.7%
n	23998	4.7%
Other values (3)	22529	4.4%

Uppercase Letter

Value	Count	Frequency (%)
E	23998	51.6%
P	21144	45.4%
S	987	2.1%
H	398	0.9%

Space Separator

Value	Count	Frequency (%)
	46527	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	23998	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	558010	88.8%
Common	70525	11.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	70525	12.6%
t	69538	12.5%
o	69454	12.4%
r	68658	12.3%
m	46527	8.3%
a	46129	8.3%
i	45142	8.1%
h	24985	4.5%
p	23998	4.3%
E	23998	4.3%
Other values (7)	69056	12.4%

Common

Value	Count	Frequency (%)
	46527	66.0%
/	23998	34.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	628535	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	70525	11.2%
t	69538	11.1%
o	69454	11.1%
r	68658	10.9%
m	46527	7.4%
	46527	7.4%
a	46129	7.3%
i	45142	7.2%
h	24985	4.0%
p	23998	3.8%
Other values (9)	117052	18.6%

price
Real number (ℝ)

SKEWED

Distinct	789
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	148.60567

Minimum	0
Maximum	10000
Zeros	22
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	0
5-th percentile	38
Q1	65
median	100
Q3	160
95-th percentile	350
Maximum	10000
Range	10000
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	318.62788
Coefficient of variation (CV)	2.1441166
Kurtosis	597.52175
Mean	148.60567
Median Absolute Deviation (MAD)	45
Skewness	21.552553
Sum	6914176
Variance	101523.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	1709	3.7%
100	1673	3.6%
50	1390	3.0%
75	1205	2.6%
60	1182	2.5%
80	1112	2.4%
70	1095	2.4%
200	1020	2.2%
65	972	2.1%
120	962	2.1%
Other values (779)	34207	73.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	< 0.1%
9	1	< 0.1%
10	4	< 0.1%
11	1	< 0.1%
14	2	< 0.1%
15	4	< 0.1%
16	10	< 0.1%
17	6	< 0.1%
18	11	< 0.1%
19	21	< 0.1%

Value	Count	Frequency (%)
10000	7	< 0.1%
9999	17	< 0.1%
9992	1	< 0.1%
9990	1	< 0.1%
9000	1	< 0.1%
8000	1	< 0.1%
7500	1	< 0.1%
7314	1	< 0.1%
7000	2	< 0.1%
6800	1	< 0.1%

minimum_nights
Real number (ℝ)

Distinct	113
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.5196338

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	6
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	23.05057
Coefficient of variation (CV)	2.7055822
Kurtosis	623.96826
Mean	8.5196338
Median Absolute Deviation (MAD)	2
Skewness	18.354597
Sum	396393
Variance	531.32876
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	11331	24.4%
2	9852	21.2%
3	7109	15.3%
30	4648	10.0%
5	3030	6.5%
4	3022	6.5%
7	2339	5.0%
14	793	1.7%
6	766	1.6%
10	572	1.2%
Other values (103)	3065	6.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11331	24.4%
2	9852	21.2%
3	7109	15.3%
4	3022	6.5%
5	3030	6.5%
6	766	1.6%
7	2339	5.0%
8	129	0.3%
9	62	0.1%
10	572	1.2%

Value	Count	Frequency (%)
1250	1	< 0.1%
1124	1	< 0.1%
1000	2	< 0.1%
999	1	< 0.1%
500	5	< 0.1%
480	1	< 0.1%
456	1	< 0.1%
400	2	< 0.1%
370	1	< 0.1%
366	1	< 0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	406
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.767167

Minimum	0
Maximum	746
Zeros	10711
Zeros (%)	23.0%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	4
Q3	21
95-th percentile	116
Maximum	746
Range	746
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	46.6039
Coefficient of variation (CV)	2.0469784
Kurtosis	22.343367
Mean	22.767167
Median Absolute Deviation (MAD)	4
Skewness	3.9426289
Sum	1059288
Variance	2171.9235
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10711	23.0%
1	5400	11.6%
2	3298	7.1%
3	2424	5.2%
4	1878	4.0%
5	1463	3.1%
6	1262	2.7%
7	1076	2.3%
8	935	2.0%
9	863	1.9%
Other values (396)	17217	37.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10711	23.0%
1	5400	11.6%
2	3298	7.1%
3	2424	5.2%
4	1878	4.0%
5	1463	3.1%
6	1262	2.7%
7	1076	2.3%
8	935	2.0%
9	863	1.9%

Value	Count	Frequency (%)
746	1	< 0.1%
695	1	< 0.1%
648	1	< 0.1%
629	1	< 0.1%
609	1	< 0.1%
561	1	< 0.1%
545	1	< 0.1%
544	1	< 0.1%
526	1	< 0.1%
522	1	< 0.1%

last_review
Date

MISSING

Distinct	2140
Distinct (%)	6.0%
Missing	10711
Missing (%)	23.0%
Memory size	363.6 KiB

Minimum	2011-05-12 00:00:00
Maximum	2020-08-16 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	775
Distinct (%)	2.2%
Missing	10711
Missing (%)	23.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.90580188

Minimum	0.01
Maximum	46.24
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.03
Q1	0.12
median	0.38
Q3	1.21
95-th percentile	3.4
Maximum	46.24
Range	46.23
Interquartile range (IQR)	1.09

Descriptive statistics

Standard deviation	1.2808978
Coefficient of variation (CV)	1.4141037
Kurtosis	63.436276
Mean	0.90580188
Median Absolute Deviation (MAD)	0.32
Skewness	4.2289832
Sum	32442.2
Variance	1.6406991
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	1393	3.0%
0.03	1161	2.5%
0.04	916	2.0%
0.05	866	1.9%
0.08	851	1.8%
0.06	808	1.7%
0.13	763	1.6%
0.07	655	1.4%
0.1	643	1.4%
0.09	611	1.3%
Other values (765)	27149	58.4%
(Missing)	10711	23.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	146	0.3%
0.02	1393	3.0%
0.03	1161	2.5%
0.04	916	2.0%
0.05	866	1.9%
0.06	808	1.7%
0.07	655	1.4%
0.08	851	1.8%
0.09	611	1.3%
0.1	643	1.4%

Value	Count	Frequency (%)
46.24	1	< 0.1%
28.2	1	< 0.1%
22.2	1	< 0.1%
18.45	1	< 0.1%
17.2	1	< 0.1%
16.02	1	< 0.1%
14	2	< 0.1%
13.95	1	< 0.1%
13.5	1	< 0.1%
13.14	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.8904507

Minimum	1
Maximum	249
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	19
Maximum	249
Range	248
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	22.731346
Coefficient of variation (CV)	3.8590165
Kurtosis	73.527813
Mean	5.8904507
Median Absolute Deviation (MAD)	0
Skewness	7.950831
Sum	274065
Variance	516.71411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	30586	65.7%
2	6196	13.3%
3	2595	5.6%
4	1344	2.9%
5	815	1.8%
6	486	1.0%
7	399	0.9%
8	392	0.8%
9	315	0.7%
249	249	0.5%
Other values (43)	3150	6.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	30586	65.7%
2	6196	13.3%
3	2595	5.6%
4	1344	2.9%
5	815	1.8%
6	486	1.0%
7	399	0.9%
8	392	0.8%
9	315	0.7%
10	210	0.5%

Value	Count	Frequency (%)
249	249	0.5%
138	138	0.3%
118	118	0.3%
98	98	0.2%
83	83	0.2%
78	78	0.2%
77	77	0.2%
74	74	0.2%
72	72	0.2%
62	62	0.1%

availability_365
Real number (ℝ)

ZEROS

Distinct	366
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.14284

Minimum	0
Maximum	365
Zeros	19967
Zeros (%)	42.9%
Negative	0
Negative (%)	0.0%
Memory size	363.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	46
Q3	252
95-th percentile	365
Maximum	365
Range	365
Interquartile range (IQR)	252

Descriptive statistics

Standard deviation	142.51775
Coefficient of variation (CV)	1.1764438
Kurtosis	-1.1292728
Mean	121.14284
Median Absolute Deviation (MAD)	46
Skewness	0.71924881
Sum	5636413
Variance	20311.309
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19967	42.9%
365	3231	6.9%
364	1343	2.9%
89	983	2.1%
179	861	1.9%
90	747	1.6%
180	665	1.4%
363	527	1.1%
88	480	1.0%
350	383	0.8%
Other values (356)	17340	37.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19967	42.9%
1	274	0.6%
2	88	0.2%
3	69	0.1%
4	60	0.1%
5	61	0.1%
6	56	0.1%
7	62	0.1%
8	51	0.1%
9	45	0.1%

Value	Count	Frequency (%)
365	3231	6.9%
364	1343	2.9%
363	527	1.1%
362	292	0.6%
361	131	0.3%
360	130	0.3%
359	168	0.4%
358	303	0.7%
357	105	0.2%
356	124	0.3%

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	neighbourhood_group	room_type
id	1.000	0.555	0.014	0.077	-0.067	0.016	-0.324	0.226	0.191	0.174	0.070	0.101
host_id	0.555	1.000	0.062	0.127	-0.113	-0.110	-0.121	0.204	0.185	0.161	0.109	0.150
latitude	0.014	0.062	1.000	0.039	0.091	0.024	-0.052	-0.038	0.042	0.028	0.541	0.106
longitude	0.077	0.127	0.039	1.000	-0.381	-0.105	0.089	0.130	0.044	0.058	0.647	0.136
price	-0.067	-0.113	0.091	-0.381	1.000	0.063	-0.025	-0.029	-0.123	0.068	0.022	0.038
minimum_nights	0.016	-0.110	0.024	-0.105	0.063	1.000	-0.148	-0.182	0.108	0.128	0.005	0.015
number_of_reviews	-0.324	-0.121	-0.052	0.089	-0.025	-0.148	1.000	0.830	0.013	0.172	0.033	0.024
reviews_per_month	0.226	0.204	-0.038	0.130	-0.029	-0.182	0.830	1.000	0.159	0.359	0.042	0.070
calculated_host_listings_count	0.191	0.185	0.042	0.044	-0.123	0.108	0.013	0.159	1.000	0.386	0.101	0.083
availability_365	0.174	0.161	0.028	0.058	0.068	0.128	0.172	0.359	0.386	1.000	0.075	0.077
neighbourhood_group	0.070	0.109	0.541	0.647	0.022	0.005	0.033	0.042	0.101	0.075	1.000	0.110
room_type	0.101	0.150	0.106	0.136	0.038	0.015	0.024	0.070	0.083	0.077	0.110	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	2595	Skylit Midtown Castle	2845	Jennifer	Manhattan	Midtown	40.75362	-73.98377	Entire home/apt	175	3	48	2019-11-04	0.37	2	365
1	3831	Whole flr w/private bdrm, bath & kitchen(pls read)	4869	LisaRoxanne	Brooklyn	Clinton Hill	40.68514	-73.95976	Entire home/apt	75	1	340	2020-08-01	4.75	1	265
2	5121	BlissArtsSpace!	7356	Garon	Brooklyn	Bedford-Stuyvesant	40.68688	-73.95596	Private room	60	29	50	2019-12-02	0.37	1	365
3	5136	Spacious Brooklyn Duplex, Patio + Garden	7378	Rebecca	Brooklyn	Sunset Park	40.66120	-73.99423	Entire home/apt	175	14	1	2014-01-02	0.01	1	295
4	5178	Large Furnished Room Near B'way	8967	Shunichi	Manhattan	Hell's Kitchen	40.76489	-73.98493	Private room	65	2	473	2020-03-15	3.44	1	340
5	5203	Cozy Clean Guest Room - Family Apt	7490	MaryEllen	Manhattan	Upper West Side	40.80178	-73.96723	Private room	75	2	118	2017-07-21	0.89	1	0
6	5238	Cute & Cozy Lower East Side 1 bdrm	7549	Ben	Manhattan	Chinatown	40.71344	-73.99037	Entire home/apt	140	1	161	2019-07-29	1.21	4	274
7	5552	Spacious river view in the West Village	8380	Maria	Manhattan	West Village	40.73552	-74.01042	Entire home/apt	160	3	66	2019-08-10	0.49	1	178
8	5803	Lovely Room 1, Garden, Best Area, Legal rental	9744	Laurie	Brooklyn	South Slope	40.66829	-73.98779	Private room	88	4	180	2020-03-18	1.31	3	344
9	6021	Wonderful Guest Bedroom in Manhattan CENTRAL PARK	11528	Claudio	Manhattan	Upper West Side	40.79826	-73.96113	Private room	85	2	123	2019-12-09	0.90	1	365

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	last_review	reviews_per_month	calculated_host_listings_count	availability_365
46517	44802032	A very large room in Williamsburg	213793805	Omer	Brooklyn	Williamsburg	40.71970	-73.95632	Private room	55	14	NaN	NaN	1	45
46518	44802224	Unique & beautiful design! Skylights-Washer/dryer	143513836	Elisabeth	Brooklyn	Crown Heights	40.67302	-73.91695	Private room	61	30	NaN	NaN	5	363
46519	44803201	1200 SF Duplex apt in an old shoe factory/ monthly	921746	Michael + Josué	Brooklyn	Clinton Hill	40.69034	-73.96179	Entire home/apt	253	30	NaN	NaN	1	74
46520	44804690	Cozy place, peaceful, friendly and affordable.	362419479	Elia	Queens	St. Albans	40.69980	-73.77104	Private room	44	1	NaN	NaN	1	161
46521	44807338	Modern luxury Chelsea one bedroom	36370873	Ashley	Manhattan	Chelsea	40.74698	-73.99512	Entire home/apt	140	7	NaN	NaN	1	358
46522	44807522	Designer Gramercy Studio Townhouse by UNSQ	12941925	Brian	Manhattan	Gramercy	40.73433	-73.98383	Entire home/apt	145	7	NaN	NaN	1	164
46523	44807786	Cozy & comfy apt in the heart of Inwood Manhattan	284790520	Salar	Manhattan	Washington Heights	40.85820	-73.92733	Entire home/apt	87	6	NaN	NaN	2	85
46524	44811717	Comfortable safe environment 24hr security camera	362453686	Nicole	Brooklyn	East Flatbush	40.65399	-73.93287	Private room	59	3	NaN	NaN	1	90
46525	44814944	Upper West Side studio 86th Street	4039777	Fernando	Manhattan	Upper West Side	40.78731	-73.97029	Entire home/apt	80	30	NaN	NaN	1	113
46526	44818009	5MIN D/N trains, NEAR THE BEACH, 50’ TO MANHATTAN	48098268	Marina	Brooklyn	Gravesend	40.59945	-73.98209	Private room	66	1	NaN	NaN	1	38

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Other Symbol

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Close Punctuation

Open Punctuation

Modifier Symbol

Dash Punctuation

Nonspacing Mark

Space Separator

Final Punctuation

Control

Initial Punctuation

Connector Punctuation

Other Number

Currency Symbol

Modifier Letter

Format

Most occurring scripts

Most frequent character per script

Han

Common

Latin

Cyrillic

Katakana

Hangul

Hiragana

Hebrew

Inherited

Georgian

Arabic

Most occurring blocks

Most frequent character per block

ASCII

Misc Symbols

Punctuation

VS

Dingbats

CJK

None

Cyrillic

Katakana

Hiragana

Arrows

Hebrew

Math Operators

Geometric Shapes

Hangul

Diacriticals

Emoticons

Georgian

Enclosed Alphanum Sup

Misc Technical

IPA Ext

Enclosed Alphanum

Arabic

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Other Symbol

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Final Punctuation

Format